@echo off
set DEFMYSQLEXE=\Program Files\MySQL\MySQL Server 5.6\bin\mysql.exe
set /p rootpass=Enter MYSQL root password:%=%
set /p mysqlexe=Where is mysql.exe? [Enter to use default "\Program Files\MySQL\MySQL Server 5.6\bin\mysql.exe"]%=%

IF [%mysqlexe%] EQU [] (
echo Data load using %DEFMYSQLEXE%
"%DEFMYSQLEXE%" --user=root  --password=%rootpass% < drop.sql
"%DEFMYSQLEXE%" --user=root  --password=%rootpass% < table.sql
"%DEFMYSQLEXE%" --user=root  --password=%rootpass% < data.sql
) ELSE (
echo Data Load using %mysqldir%\bin\mysql.exe
%mysqlexe% --user=root  --password=%rootpass% < drop.sql
%mysqlexe% --user=root  --password=%rootpass% < table.sql
%mysqlexe% --user=root  --password=%rootpass% < data.sql
)

echo.
echo.
echo Data load done.... Exit status: %ERRORLEVEL%
echo.
echo If you had any issues loading, run the following manually
echo      path/to/mysql.exe --user=root  --password=root_password ^< drop.sql
echo      path/to/mysql.exe --user=root  --password=root_password ^< table.sql
echo      path/to/mysql.exe --user=root  --password=root_password ^< data.sql
echo.
set /p cont=Press any key to exit...